package com.vp.org.constant;

public interface UserSql {

    // 添加用户
    String ADD_USER = "INSERT INTO USER_INFO (PHONE, PASSWORD, EMAIL, QQ, NICKNAME, ADDRESS, SCHOOL, GRADE, CLASSNAME, PROVINCE, CITY, DISTRICT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ? ,? ,?)";

    // 修改用户
    String UPDATE_USER = "UPDATE USER_INFO SET TYPE = ?, USERNAME = ?, GENDER = ?, EMAIL = ?, QQ = ?, SCHOOL = ?, CLASSNAME = ?, BIRTHDAY = ?, HOBBY = ?, INTRODUCE = ?, picture = ? WHERE USER_ID = ?";

    // 通过手机号检查用户名是否存在
    String CHECK_PHONE = "SELECT PHONE FROM USER_INFO WHERE PHONE = ?";

    // 登入检测
    String CHECK_USER = "SELECT USER_ID FROM USER_INFO WHERE PHONE = ? AND PASSWORD = ?";

    // 用户登入
    String Login_USER = "SELECT USER_ID, NICKNAME, PICTURE FROM USER_INFO WHERE PHONE = ? AND PASSWORD = ?";

}
